#!/usr/bin/env python3
# -*- coding: utf-8 -*-

# 导入MySQL驱动:
import mysql.connector

"""
使用前安装mysql 驱动
pip install mysql-connector-python
or
pip install mysql-connector
"""



def init():
    # 注意把password设为你的root口令:
    conn = mysql.connector.connect(user='root', password='abc@123A', database='test')
    cursor = conn.cursor()
    # 创建user表:
    cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
    # 插入一行记录，注意MySQL的占位符是%s:
    cursor.execute('insert into user (id, name) values (%s, %s)', ['1', 'Michael'])
    print(cursor.rowcount)

    # 提交事务:
    conn.commit()
    cursor.close()
    # 运行查询:
    cursor = conn.cursor()
    cursor.execute('select * from user where id = %s', ('1',))
    values = cursor.fetchall()
    print(values)

init()